Year 9 Modelling
The aim of the Unit is to teach you dropdowns and lookups, and to be able to apply that in (relatively) realistic situations.
Google Sheets Version
- Lesson 1 Video 1 - Dropdowns
- Lesson 1 Video 2 - IF statements
- Lesson 2 Video 1 - Vlookups for text
- Lesson 2 Video 2 - Vlookups with numeric ranges
Excel Version
Either Version
- Lessop 3 Video1 - The first sheet of the exercise
- Lesson 3 Video2 - The second sheet of the exercise
- Lesson 4 Video - Practice Exercise 3
Instructions for the end of unit assessment :
Additional Help - Using Excel at Home
To work from home you need to know how to download the Excel files from Classroom :
For those that don't have a desktop version of Excel available, the following supplementary videos are there to help :